Overview
Brought to you by YData
Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 1177 |
| Missing cells | 108 |
| Missing cells (%) | 0.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 571.8 KiB |
| Average record size in memory | 497.5 B |
Variable types
| DateTime | 2 |
|---|---|
| Categorical | 2 |
| Numeric | 20 |
cpc总费用 is highly overall correlated with cpc曝光量 and 8 other fields | High correlation |
cpc曝光量 is highly overall correlated with cpc总费用 and 8 other fields | High correlation |
cpc访问量 is highly overall correlated with cpc总费用 and 9 other fields | High correlation |
gmvroi is highly overall correlated with 下单转换率 and 1 other fields | High correlation |
下单转换率 is highly overall correlated with gmvroi and 1 other fields | High correlation |
单均gmv is highly overall correlated with 单均实收 and 3 other fields | High correlation |
单均实收 is highly overall correlated with 单均gmv and 1 other fields | High correlation |
实收roi is highly overall correlated with gmvroi and 3 other fields | High correlation |
平台i is highly overall correlated with 平台门店名称 and 1 other fields | High correlation |
平台门店名称 is highly overall correlated with 平台i and 1 other fields | High correlation |
有效订单 is highly overall correlated with cpc总费用 and 10 other fields | High correlation |
自增主键 is highly overall correlated with cpc访问量 and 1 other fields | High correlation |
自然曝光量 is highly overall correlated with 有效订单 and 6 other fields | High correlation |
自然访问量 is highly overall correlated with cpc总费用 and 9 other fields | High correlation |
门店ID is highly overall correlated with 平台i and 1 other fields | High correlation |
门店下单量 is highly overall correlated with cpc总费用 and 10 other fields | High correlation |
门店实收 is highly overall correlated with cpc总费用 and 9 other fields | High correlation |
门店曝光量 is highly overall correlated with cpc总费用 and 9 other fields | High correlation |
门店营业额 is highly overall correlated with cpc总费用 and 9 other fields | High correlation |
门店访问量 is highly overall correlated with cpc总费用 and 10 other fields | High correlation |
cpc单次点击费用 has 12 (1.0%) missing values | Missing |
自然曝光量 has 12 (1.0%) missing values | Missing |
自然访问量 has 12 (1.0%) missing values | Missing |
门店下单量 has 12 (1.0%) missing values | Missing |
门店曝光量 has 12 (1.0%) missing values | Missing |
门店访问量 has 12 (1.0%) missing values | Missing |
gmvroi is highly skewed (γ1 = 31.91391675) | Skewed |
实收roi is highly skewed (γ1 = 31.32709453) | Skewed |
自增主键 has unique values | Unique |
cpc总费用 has 12 (1.0%) zeros | Zeros |
cpc访问量 has 12 (1.0%) zeros | Zeros |
gmvroi has 22 (1.9%) zeros | Zeros |
下单转换率 has 13 (1.1%) zeros | Zeros |
实收roi has 22 (1.9%) zeros | Zeros |
无效订单 has 781 (66.4%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-04 07:01:35.330629 |
|---|---|
| Analysis finished | 2025-11-04 07:01:50.484356 |
| Duration | 15.15 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
updateTime
Date
| Distinct | 374 |
|---|---|
| Distinct (%) | 31.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.3 KiB |
| Minimum | 2019-12-12 11:54:00 |
|---|---|
| Maximum | 2020-09-26 14:20:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
平台i
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 92.2 KiB |
| 饿了么 | |
|---|---|
| 美团 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.6210705 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 美团 |
|---|---|
| 2nd row | 美团 |
| 3rd row | 美团 |
| 4th row | 美团 |
| 5th row | 饿了么 |
Common Values
| Value | Count | Frequency (%) |
| 饿了么 | 731 | |
| 美团 | 446 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 饿了么 | 731 | |
| 美团 | 446 |
Most occurring characters
| Value | Count | Frequency (%) |
| 饿 | 731 | |
| 了 | 731 | |
| 么 | 731 | |
| 美 | 446 | |
| 团 | 446 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3085 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 饿 | 731 | |
| 了 | 731 | |
| 么 | 731 | |
| 美 | 446 | |
| 团 | 446 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3085 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 饿 | 731 | |
| 了 | 731 | |
| 么 | 731 | |
| 美 | 446 | |
| 团 | 446 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3085 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 饿 | 731 | |
| 了 | 731 | |
| 么 | 731 | |
| 美 | 446 | |
| 团 | 446 |
门店ID
Real number (ℝ)
High correlation
| Distinct | 18 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1027077 × 109 |
| Minimum | 8052557 |
|---|---|
| Maximum | 2.001573 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 8052557 |
|---|---|
| 5-th percentile | 8106681 |
| Q1 | 8491999 |
| median | 2.0005071 × 109 |
| Q3 | 2.0011044 × 109 |
| 95-th percentile | 2.001221 × 109 |
| Maximum | 2.001573 × 109 |
| Range | 1.9935204 × 109 |
| Interquartile range (IQR) | 1.9926124 × 109 |
Descriptive statistics
| Standard deviation | 9.681788 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.87800129 |
| Kurtosis | -1.9519444 |
| Mean | 1.1027077 × 109 |
| Median Absolute Deviation (MAD) | 713877 |
| Skewness | -0.1634554 |
| Sum | 1.297887 × 1012 |
| Variance | 9.3737018 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=18)
| Value | Count | Frequency (%) |
| 2001104355 | 271 | |
| 8491999 | 191 | |
| 2000507076 | 110 | |
| 2000555792 | 88 | 7.5% |
| 337460136 | 85 | 7.2% |
| 2001220953 | 68 | 5.8% |
| 2001020019 | 64 | 5.4% |
| 8165842 | 61 | 5.2% |
| 8184590 | 48 | 4.1% |
| 8052557 | 40 | 3.4% |
| Other values (8) | 151 |
| Value | Count | Frequency (%) |
| 8052557 | 40 | 3.4% |
| 8106681 | 31 | 2.6% |
| 8165842 | 61 | 5.2% |
| 8184590 | 48 | 4.1% |
| 8223184 | 20 | 1.7% |
| 8260331 | 29 | 2.5% |
| 8491999 | 191 | |
| 9428110 | 26 | 2.2% |
| 305225345 | 16 | 1.4% |
| 337460136 | 85 |
| Value | Count | Frequency (%) |
| 2001572992 | 2 | 0.2% |
| 2001220953 | 68 | 5.8% |
| 2001104355 | 271 | |
| 2001053699 | 18 | 1.5% |
| 2001042552 | 9 | 0.8% |
| 2001020019 | 64 | 5.4% |
| 2000555792 | 88 | 7.5% |
| 2000507076 | 110 | |
| 337460136 | 85 | 7.2% |
| 305225345 | 16 | 1.4% |
平台门店名称
Categorical
High correlation
| Distinct | 31 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 154.7 KiB |
| 蛙小辣火锅杯（宝山店） | |
|---|---|
| 蛙小辣·美蛙火锅杯麻辣烫(宝山店) | |
| 蛙小辣·美蛙火锅杯(宝山店) | |
| 蛙小辣·美蛙火锅杯(虹口足球场店) | |
| 拌客·干拌麻辣烫(武宁路店) | |
| Other values (26) |
Length
| Max length | 18 |
|---|---|
| Median length | 17 |
| Mean length | 14.100255 |
| Min length | 6 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | 蛙小辣火锅杯（合生汇店） |
|---|---|
| 2nd row | 蛙小辣美蛙火锅杯（大宁国际店） |
| 3rd row | 蛙小辣·美蛙火锅杯（长风大悦城店） |
| 4th row | 蛙小辣·美蛙火锅杯（虹口足球场店） |
| 5th row | 利芳·一人食大盘鸡(国定路店) |
Common Values
| Value | Count | Frequency (%) |
| 蛙小辣火锅杯（宝山店） | 191 | |
| 蛙小辣·美蛙火锅杯麻辣烫(宝山店) | 164 | |
| 蛙小辣·美蛙火锅杯(宝山店) | 107 | 9.1% |
| 蛙小辣·美蛙火锅杯(虹口足球场店) | 88 | 7.5% |
| 拌客·干拌麻辣烫(武宁路店) | 83 | 7.1% |
| 蛙小辣火锅杯(五角场店) | 76 | 6.5% |
| 蛙小辣·美蛙火锅杯(真如店) | 58 | 4.9% |
| 蛙小辣·美蛙火锅杯（虹口足球场店） | 55 | 4.7% |
| 利芳·一人食大盘鸡(国定路店) | 44 | 3.7% |
| 蛙小辣火锅杯（合生汇店） | 34 | 2.9% |
| Other values (21) | 277 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 蛙小辣火锅杯（宝山店） | 191 | |
| 蛙小辣·美蛙火锅杯麻辣烫(宝山店 | 164 | |
| 蛙小辣·美蛙火锅杯(宝山店 | 107 | 9.1% |
| 蛙小辣·美蛙火锅杯(虹口足球场店 | 88 | 7.5% |
| 拌客·干拌麻辣烫(武宁路店 | 83 | 7.1% |
| 蛙小辣火锅杯(五角场店 | 76 | 6.5% |
| 蛙小辣·美蛙火锅杯(真如店 | 58 | 4.9% |
| 蛙小辣·美蛙火锅杯（虹口足球场店） | 55 | 4.7% |
| 利芳·一人食大盘鸡(国定路店 | 44 | 3.7% |
| 蛙小辣火锅杯（合生汇店） | 34 | 2.9% |
| Other values (21) | 277 |
Most occurring characters
| Value | Count | Frequency (%) |
| 蛙 | 1612 | 9.7% |
| 辣 | 1289 | 7.8% |
| 店 | 1171 | 7.1% |
| 火 | 998 | 6.0% |
| 锅 | 998 | 6.0% |
| 杯 | 998 | 6.0% |
| 小 | 998 | 6.0% |
| ( | 726 | 4.4% |
| ) | 726 | 4.4% |
| · | 682 | 4.1% |
| Other values (48) | 6398 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16596 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 蛙 | 1612 | 9.7% |
| 辣 | 1289 | 7.8% |
| 店 | 1171 | 7.1% |
| 火 | 998 | 6.0% |
| 锅 | 998 | 6.0% |
| 杯 | 998 | 6.0% |
| 小 | 998 | 6.0% |
| ( | 726 | 4.4% |
| ) | 726 | 4.4% |
| · | 682 | 4.1% |
| Other values (48) | 6398 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16596 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 蛙 | 1612 | 9.7% |
| 辣 | 1289 | 7.8% |
| 店 | 1171 | 7.1% |
| 火 | 998 | 6.0% |
| 锅 | 998 | 6.0% |
| 杯 | 998 | 6.0% |
| 小 | 998 | 6.0% |
| ( | 726 | 4.4% |
| ) | 726 | 4.4% |
| · | 682 | 4.1% |
| Other values (48) | 6398 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16596 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 蛙 | 1612 | 9.7% |
| 辣 | 1289 | 7.8% |
| 店 | 1171 | 7.1% |
| 火 | 998 | 6.0% |
| 锅 | 998 | 6.0% |
| 杯 | 998 | 6.0% |
| 小 | 998 | 6.0% |
| ( | 726 | 4.4% |
| ) | 726 | 4.4% |
| · | 682 | 4.1% |
| Other values (48) | 6398 |
日期
Date
| Distinct | 315 |
|---|---|
| Distinct (%) | 26.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.3 KiB |
| Minimum | 2019-10-28 00:00:00 |
|---|---|
| Maximum | 2020-09-25 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
cpc单次点击费用
Real number (ℝ)
Missing
| Distinct | 166 |
|---|---|
| Distinct (%) | 14.2% |
| Missing | 12 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3896223 |
| Minimum | 0.02 |
|---|---|
| Maximum | 2.98 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0.02 |
|---|---|
| 5-th percentile | 0.892 |
| Q1 | 1.24 |
| median | 1.38 |
| Q3 | 1.54 |
| 95-th percentile | 1.96 |
| Maximum | 2.98 |
| Range | 2.96 |
| Interquartile range (IQR) | 0.3 |
Descriptive statistics
| Standard deviation | 0.30395027 |
|---|---|
| Coefficient of variation (CV) | 0.21872869 |
| Kurtosis | 2.0768236 |
| Mean | 1.3896223 |
| Median Absolute Deviation (MAD) | 0.15 |
| Skewness | 0.21229082 |
| Sum | 1618.91 |
| Variance | 0.092385768 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.4 | 35 | 3.0% |
| 1.39 | 31 | 2.6% |
| 1.38 | 29 | 2.5% |
| 1.43 | 27 | 2.3% |
| 1.31 | 26 | 2.2% |
| 1.33 | 26 | 2.2% |
| 1.32 | 23 | 2.0% |
| 1.41 | 22 | 1.9% |
| 1.28 | 22 | 1.9% |
| 1.34 | 21 | 1.8% |
| Other values (156) | 903 |
| Value | Count | Frequency (%) |
| 0.02 | 1 | 0.1% |
| 0.27 | 1 | 0.1% |
| 0.44 | 2 | |
| 0.51 | 1 | 0.1% |
| 0.56 | 1 | 0.1% |
| 0.58 | 4 | |
| 0.59 | 2 | |
| 0.61 | 3 | |
| 0.62 | 1 | 0.1% |
| 0.63 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 2.98 | 1 | 0.1% |
| 2.5 | 1 | 0.1% |
| 2.47 | 1 | 0.1% |
| 2.34 | 1 | 0.1% |
| 2.3 | 1 | 0.1% |
| 2.28 | 1 | 0.1% |
| 2.27 | 1 | 0.1% |
| 2.26 | 1 | 0.1% |
| 2.25 | 3 | |
| 2.24 | 2 |
cpc总费用
Real number (ℝ)
High correlation Zeros
| Distinct | 1017 |
|---|---|
| Distinct (%) | 86.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 129.58017 |
| Minimum | 0 |
|---|---|
| Maximum | 846.4 |
| Zeros | 12 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 12.544 |
| Q1 | 39.91 |
| median | 76.2 |
| Q3 | 190 |
| 95-th percentile | 416.972 |
| Maximum | 846.4 |
| Range | 846.4 |
| Interquartile range (IQR) | 150.09 |
Descriptive statistics
| Standard deviation | 134.53922 |
|---|---|
| Coefficient of variation (CV) | 1.0382701 |
| Kurtosis | 5.3166983 |
| Mean | 129.58017 |
| Median Absolute Deviation (MAD) | 51 |
| Skewness | 2.0911377 |
| Sum | 152515.86 |
| Variance | 18100.802 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50 | 30 | 2.5% |
| 80 | 15 | 1.3% |
| 0 | 12 | 1.0% |
| 100 | 9 | 0.8% |
| 60 | 8 | 0.7% |
| 300 | 8 | 0.7% |
| 150 | 5 | 0.4% |
| 400 | 5 | 0.4% |
| 250 | 4 | 0.3% |
| 29.9 | 3 | 0.3% |
| Other values (1007) | 1078 |
| Value | Count | Frequency (%) |
| 0 | 12 | |
| 0.02 | 1 | 0.1% |
| 0.44 | 1 | 0.1% |
| 0.94 | 1 | 0.1% |
| 1 | 1 | 0.1% |
| 1.1 | 1 | 0.1% |
| 1.28 | 1 | 0.1% |
| 1.3 | 2 | 0.2% |
| 1.4 | 2 | 0.2% |
| 2 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 846.4 | 1 | 0.1% |
| 800 | 1 | 0.1% |
| 768.15 | 1 | 0.1% |
| 762.8 | 1 | 0.1% |
| 757.95 | 1 | 0.1% |
| 700 | 2 | |
| 699.7 | 2 | |
| 699.6 | 1 | 0.1% |
| 699.4 | 3 | |
| 699.1 | 1 | 0.1% |
cpc曝光量
Real number (ℝ)
High correlation
| Distinct | 944 |
|---|---|
| Distinct (%) | 80.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1350.9864 |
| Minimum | 0 |
|---|---|
| Maximum | 7812 |
| Zeros | 8 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 145.6 |
| Q1 | 466 |
| median | 863 |
| Q3 | 1950 |
| 95-th percentile | 3822 |
| Maximum | 7812 |
| Range | 7812 |
| Interquartile range (IQR) | 1484 |
Descriptive statistics
| Standard deviation | 1256.423 |
|---|---|
| Coefficient of variation (CV) | 0.93000417 |
| Kurtosis | 3.5180955 |
| Mean | 1350.9864 |
| Median Absolute Deviation (MAD) | 536 |
| Skewness | 1.7148962 |
| Sum | 1590111 |
| Variance | 1578598.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 8 | 0.7% |
| 1 | 6 | 0.5% |
| 640 | 4 | 0.3% |
| 650 | 4 | 0.3% |
| 521 | 4 | 0.3% |
| 362 | 4 | 0.3% |
| 327 | 4 | 0.3% |
| 349 | 4 | 0.3% |
| 617 | 3 | 0.3% |
| 524 | 3 | 0.3% |
| Other values (934) | 1133 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 1 | 6 | |
| 2 | 3 | 0.3% |
| 3 | 2 | 0.2% |
| 4 | 1 | 0.1% |
| 5 | 1 | 0.1% |
| 7 | 2 | 0.2% |
| 8 | 2 | 0.2% |
| 12 | 1 | 0.1% |
| 17 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 7812 | 1 | |
| 7481 | 1 | |
| 7466 | 1 | |
| 7178 | 1 | |
| 6941 | 1 | |
| 6710 | 1 | |
| 6198 | 1 | |
| 6143 | 1 | |
| 6119 | 1 | |
| 5964 | 1 |
cpc访问量
Real number (ℝ)
High correlation Zeros
| Distinct | 291 |
|---|---|
| Distinct (%) | 24.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.31096 |
| Minimum | 0 |
|---|---|
| Maximum | 502 |
| Zeros | 12 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 29 |
| median | 57 |
| Q3 | 133 |
| 95-th percentile | 260.6 |
| Maximum | 502 |
| Range | 502 |
| Interquartile range (IQR) | 104 |
Descriptive statistics
| Standard deviation | 87.907575 |
|---|---|
| Coefficient of variation (CV) | 0.96272752 |
| Kurtosis | 3.6060928 |
| Mean | 91.31096 |
| Median Absolute Deviation (MAD) | 36 |
| Skewness | 1.7762244 |
| Sum | 107473 |
| Variance | 7727.7417 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 27 | 25 | 2.1% |
| 32 | 20 | 1.7% |
| 25 | 18 | 1.5% |
| 26 | 18 | 1.5% |
| 21 | 17 | 1.4% |
| 17 | 17 | 1.4% |
| 34 | 17 | 1.4% |
| 33 | 16 | 1.4% |
| 29 | 16 | 1.4% |
| 35 | 16 | 1.4% |
| Other values (281) | 997 |
| Value | Count | Frequency (%) |
| 0 | 12 | |
| 1 | 10 | |
| 2 | 5 | |
| 3 | 2 | 0.2% |
| 4 | 4 | 0.3% |
| 5 | 7 | |
| 6 | 3 | 0.3% |
| 7 | 4 | 0.3% |
| 8 | 4 | 0.3% |
| 9 | 5 |
| Value | Count | Frequency (%) |
| 502 | 1 | |
| 499 | 1 | |
| 489 | 1 | |
| 479 | 1 | |
| 465 | 1 | |
| 457 | 1 | |
| 437 | 1 | |
| 433 | 1 | |
| 430 | 1 | |
| 427 | 1 |
gmvroi
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 699 |
|---|---|
| Distinct (%) | 59.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.5499065 |
| Minimum | 0 |
|---|---|
| Maximum | 534.66 |
| Zeros | 22 |
| Zeros (%) | 1.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3.408 |
| Q1 | 6.04 |
| median | 7.59 |
| Q3 | 9.85 |
| 95-th percentile | 14.592 |
| Maximum | 534.66 |
| Range | 534.66 |
| Interquartile range (IQR) | 3.81 |
Descriptive statistics
| Standard deviation | 15.723512 |
|---|---|
| Coefficient of variation (CV) | 1.8390274 |
| Kurtosis | 1068.3177 |
| Mean | 8.5499065 |
| Median Absolute Deviation (MAD) | 1.84 |
| Skewness | 31.913917 |
| Sum | 10063.24 |
| Variance | 247.22884 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 22 | 1.9% |
| 6.06 | 7 | 0.6% |
| 9.18 | 7 | 0.6% |
| 7.36 | 5 | 0.4% |
| 5.23 | 5 | 0.4% |
| 8.57 | 5 | 0.4% |
| 6.56 | 5 | 0.4% |
| 6.6 | 5 | 0.4% |
| 6.32 | 5 | 0.4% |
| 10.88 | 5 | 0.4% |
| Other values (689) | 1106 |
| Value | Count | Frequency (%) |
| 0 | 22 | |
| 2.06 | 1 | 0.1% |
| 2.24 | 1 | 0.1% |
| 2.28 | 1 | 0.1% |
| 2.32 | 1 | 0.1% |
| 2.42 | 1 | 0.1% |
| 2.48 | 1 | 0.1% |
| 2.51 | 1 | 0.1% |
| 2.75 | 2 | 0.2% |
| 2.79 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 534.66 | 1 | |
| 28.76 | 1 | |
| 24.2 | 1 | |
| 22.76 | 1 | |
| 22.32 | 1 | |
| 20.71 | 1 | |
| 20.24 | 1 | |
| 20.17 | 1 | |
| 20.13 | 1 | |
| 18.4 | 1 |
下单转换率
Real number (ℝ)
High correlation Zeros
| Distinct | 36 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.18851317 |
| Minimum | 0 |
|---|---|
| Maximum | 0.42 |
| Zeros | 13 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.09 |
| Q1 | 0.15 |
| median | 0.19 |
| Q3 | 0.23 |
| 95-th percentile | 0.29 |
| Maximum | 0.42 |
| Range | 0.42 |
| Interquartile range (IQR) | 0.08 |
Descriptive statistics
| Standard deviation | 0.063103535 |
|---|---|
| Coefficient of variation (CV) | 0.33474338 |
| Kurtosis | 0.31726042 |
| Mean | 0.18851317 |
| Median Absolute Deviation (MAD) | 0.04 |
| Skewness | 0.043805661 |
| Sum | 221.88 |
| Variance | 0.0039820562 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 0.18 | 86 | 7.3% |
| 0.15 | 76 | 6.5% |
| 0.21 | 73 | 6.2% |
| 0.14 | 73 | 6.2% |
| 0.17 | 72 | 6.1% |
| 0.19 | 70 | 5.9% |
| 0.2 | 68 | 5.8% |
| 0.23 | 58 | 4.9% |
| 0.16 | 56 | 4.8% |
| 0.22 | 56 | 4.8% |
| Other values (26) | 489 |
| Value | Count | Frequency (%) |
| 0 | 13 | 1.1% |
| 0.04 | 2 | 0.2% |
| 0.05 | 4 | 0.3% |
| 0.06 | 3 | 0.3% |
| 0.07 | 11 | 0.9% |
| 0.08 | 18 | 1.5% |
| 0.09 | 18 | 1.5% |
| 0.1 | 19 | 1.6% |
| 0.11 | 30 | |
| 0.12 | 48 |
| Value | Count | Frequency (%) |
| 0.42 | 1 | 0.1% |
| 0.38 | 3 | 0.3% |
| 0.36 | 3 | 0.3% |
| 0.35 | 1 | 0.1% |
| 0.34 | 5 | 0.4% |
| 0.33 | 7 | 0.6% |
| 0.32 | 9 | 0.8% |
| 0.31 | 10 | |
| 0.3 | 19 | |
| 0.29 | 23 |
单均gmv
Real number (ℝ)
High correlation
| Distinct | 943 |
|---|---|
| Distinct (%) | 80.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57.694299 |
| Minimum | 0 |
|---|---|
| Maximum | 90.76 |
| Zeros | 9 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 45.632 |
| Q1 | 52.99 |
| median | 57.81 |
| Q3 | 62.74 |
| 95-th percentile | 71.372 |
| Maximum | 90.76 |
| Range | 90.76 |
| Interquartile range (IQR) | 9.75 |
Descriptive statistics
| Standard deviation | 9.2282739 |
|---|---|
| Coefficient of variation (CV) | 0.15995123 |
| Kurtosis | 10.526872 |
| Mean | 57.694299 |
| Median Absolute Deviation (MAD) | 4.89 |
| Skewness | -1.5984278 |
| Sum | 67906.19 |
| Variance | 85.161038 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 9 | 0.8% |
| 52.84 | 5 | 0.4% |
| 68.77 | 4 | 0.3% |
| 51.64 | 3 | 0.3% |
| 54.1 | 3 | 0.3% |
| 52.78 | 3 | 0.3% |
| 59.76 | 3 | 0.3% |
| 58.66 | 3 | 0.3% |
| 54.2 | 3 | 0.3% |
| 63.91 | 3 | 0.3% |
| Other values (933) | 1138 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 32.8 | 1 | 0.1% |
| 37.11 | 1 | 0.1% |
| 38.56 | 1 | 0.1% |
| 38.71 | 1 | 0.1% |
| 39 | 1 | 0.1% |
| 39.36 | 1 | 0.1% |
| 39.39 | 1 | 0.1% |
| 39.77 | 1 | 0.1% |
| 39.88 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 90.76 | 1 | |
| 86.88 | 1 | |
| 85.27 | 1 | |
| 85.17 | 1 | |
| 84.62 | 1 | |
| 81.21 | 1 | |
| 80.63 | 1 | |
| 80.22 | 1 | |
| 79.97 | 1 | |
| 79.36 | 1 |
单均实收
Real number (ℝ)
High correlation
| Distinct | 844 |
|---|---|
| Distinct (%) | 71.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.699456 |
| Minimum | 0 |
|---|---|
| Maximum | 47.32 |
| Zeros | 9 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 13.732 |
| Q1 | 17.82 |
| median | 20.53 |
| Q3 | 23.53 |
| 95-th percentile | 28.692 |
| Maximum | 47.32 |
| Range | 47.32 |
| Interquartile range (IQR) | 5.71 |
Descriptive statistics
| Standard deviation | 5.2444284 |
|---|---|
| Coefficient of variation (CV) | 0.25336068 |
| Kurtosis | 3.204278 |
| Mean | 20.699456 |
| Median Absolute Deviation (MAD) | 2.87 |
| Skewness | -0.14951894 |
| Sum | 24363.26 |
| Variance | 27.504029 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 9 | 0.8% |
| 20.65 | 7 | 0.6% |
| 22.04 | 5 | 0.4% |
| 19.8 | 4 | 0.3% |
| 19.17 | 4 | 0.3% |
| 20.51 | 4 | 0.3% |
| 18.24 | 4 | 0.3% |
| 20.3 | 4 | 0.3% |
| 19.42 | 4 | 0.3% |
| 24.07 | 4 | 0.3% |
| Other values (834) | 1128 |
| Value | Count | Frequency (%) |
| 0 | 9 | |
| 3.04 | 1 | 0.1% |
| 3.6 | 1 | 0.1% |
| 3.72 | 1 | 0.1% |
| 3.75 | 1 | 0.1% |
| 3.8 | 1 | 0.1% |
| 4.15 | 1 | 0.1% |
| 4.2 | 1 | 0.1% |
| 4.34 | 1 | 0.1% |
| 4.42 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 47.32 | 1 | |
| 40.01 | 1 | |
| 39.81 | 1 | |
| 39.59 | 1 | |
| 38.72 | 1 | |
| 38.26 | 1 | |
| 38.07 | 1 | |
| 37.24 | 2 | |
| 37 | 1 | |
| 35.69 | 1 |
实收roi
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 433 |
|---|---|
| Distinct (%) | 36.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.0534579 |
| Minimum | 0 |
|---|---|
| Maximum | 189.32 |
| Zeros | 22 |
| Zeros (%) | 1.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.148 |
| Q1 | 2.02 |
| median | 2.66 |
| Q3 | 3.6 |
| 95-th percentile | 5.26 |
| Maximum | 189.32 |
| Range | 189.32 |
| Interquartile range (IQR) | 1.58 |
Descriptive statistics
| Standard deviation | 5.6018115 |
|---|---|
| Coefficient of variation (CV) | 1.8345795 |
| Kurtosis | 1041.8185 |
| Mean | 3.0534579 |
| Median Absolute Deviation (MAD) | 0.75 |
| Skewness | 31.327095 |
| Sum | 3593.92 |
| Variance | 31.380292 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 22 | 1.9% |
| 2.96 | 11 | 0.9% |
| 1.96 | 10 | 0.8% |
| 2.54 | 9 | 0.8% |
| 1.73 | 9 | 0.8% |
| 2.67 | 8 | 0.7% |
| 2.38 | 8 | 0.7% |
| 3.18 | 8 | 0.7% |
| 3.32 | 8 | 0.7% |
| 2.18 | 7 | 0.6% |
| Other values (423) | 1077 |
| Value | Count | Frequency (%) |
| 0 | 22 | |
| 0.27 | 1 | 0.1% |
| 0.55 | 1 | 0.1% |
| 0.57 | 2 | 0.2% |
| 0.58 | 1 | 0.1% |
| 0.61 | 1 | 0.1% |
| 0.64 | 1 | 0.1% |
| 0.69 | 1 | 0.1% |
| 0.72 | 1 | 0.1% |
| 0.75 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 189.32 | 1 | |
| 13.28 | 1 | |
| 10.5 | 1 | |
| 9.37 | 1 | |
| 8.37 | 1 | |
| 8.23 | 1 | |
| 7.87 | 1 | |
| 7.79 | 1 | |
| 7.78 | 1 | |
| 7.14 | 1 |
无效订单
Real number (ℝ)
Zeros
| Distinct | 12 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 9 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.6010274 |
| Minimum | 0 |
|---|---|
| Maximum | 12 |
| Zeros | 781 |
| Zeros (%) | 66.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 12 |
| Range | 12 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.1883751 |
|---|---|
| Coefficient of variation (CV) | 1.9772395 |
| Kurtosis | 19.926246 |
| Mean | 0.6010274 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.5734738 |
| Sum | 702 |
| Variance | 1.4122354 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 0 | 781 | |
| 1 | 231 | 19.6% |
| 2 | 81 | 6.9% |
| 3 | 38 | 3.2% |
| 4 | 18 | 1.5% |
| 5 | 10 | 0.8% |
| 6 | 3 | 0.3% |
| 7 | 2 | 0.2% |
| 12 | 1 | 0.1% |
| 10 | 1 | 0.1% |
| Other values (2) | 2 | 0.2% |
| (Missing) | 9 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 781 | |
| 1 | 231 | 19.6% |
| 2 | 81 | 6.9% |
| 3 | 38 | 3.2% |
| 4 | 18 | 1.5% |
| 5 | 10 | 0.8% |
| 6 | 3 | 0.3% |
| 7 | 2 | 0.2% |
| 8 | 1 | 0.1% |
| 10 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 12 | 1 | 0.1% |
| 11 | 1 | 0.1% |
| 10 | 1 | 0.1% |
| 8 | 1 | 0.1% |
| 7 | 2 | 0.2% |
| 6 | 3 | 0.3% |
| 5 | 10 | 0.8% |
| 4 | 18 | 1.5% |
| 3 | 38 | |
| 2 | 81 |
有效订单
Real number (ℝ)
High correlation
| Distinct | 145 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 9 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41.988014 |
| Minimum | 4 |
|---|---|
| Maximum | 232 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 9.35 |
| Q1 | 17 |
| median | 26 |
| Q3 | 61.25 |
| 95-th percentile | 111 |
| Maximum | 232 |
| Range | 228 |
| Interquartile range (IQR) | 44.25 |
Descriptive statistics
| Standard deviation | 35.579085 |
|---|---|
| Coefficient of variation (CV) | 0.84736291 |
| Kurtosis | 3.7589166 |
| Mean | 41.988014 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 1.7601322 |
| Sum | 49042 |
| Variance | 1265.8713 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 19 | 56 | 4.8% |
| 15 | 52 | 4.4% |
| 18 | 42 | 3.6% |
| 17 | 40 | 3.4% |
| 12 | 35 | 3.0% |
| 16 | 35 | 3.0% |
| 21 | 31 | 2.6% |
| 22 | 31 | 2.6% |
| 20 | 29 | 2.5% |
| 11 | 27 | 2.3% |
| Other values (135) | 790 |
| Value | Count | Frequency (%) |
| 4 | 5 | 0.4% |
| 5 | 8 | 0.7% |
| 6 | 6 | 0.5% |
| 7 | 9 | 0.8% |
| 8 | 15 | |
| 9 | 16 | |
| 10 | 17 | |
| 11 | 27 | |
| 12 | 35 | |
| 13 | 24 |
| Value | Count | Frequency (%) |
| 232 | 1 | |
| 207 | 2 | |
| 201 | 1 | |
| 198 | 1 | |
| 195 | 1 | |
| 191 | 1 | |
| 189 | 1 | |
| 186 | 1 | |
| 181 | 2 | |
| 175 | 1 |
自增主键
Real number (ℝ)
High correlation Unique
| Distinct | 1177 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3023888.6 |
| Minimum | 1501603 |
|---|---|
| Maximum | 7684897 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 1501603 |
|---|---|
| 5-th percentile | 1516524.2 |
| Q1 | 1872058 |
| median | 2538079 |
| Q3 | 3775030 |
| 95-th percentile | 6103567.8 |
| Maximum | 7684897 |
| Range | 6183294 |
| Interquartile range (IQR) | 1902972 |
Descriptive statistics
| Standard deviation | 1433359.6 |
|---|---|
| Coefficient of variation (CV) | 0.47401205 |
| Kurtosis | 0.68880151 |
| Mean | 3023888.6 |
| Median Absolute Deviation (MAD) | 830976 |
| Skewness | 1.1639821 |
| Sum | 3.5591169 × 109 |
| Variance | 2.0545198 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1501603 | 1 | 0.1% |
| 3177288 | 1 | 0.1% |
| 3261191 | 1 | 0.1% |
| 3248237 | 1 | 0.1% |
| 3248033 | 1 | 0.1% |
| 3235264 | 1 | 0.1% |
| 3234719 | 1 | 0.1% |
| 3234505 | 1 | 0.1% |
| 3220687 | 1 | 0.1% |
| 3220027 | 1 | 0.1% |
| Other values (1167) | 1167 |
| Value | Count | Frequency (%) |
| 1501603 | 1 | |
| 1501605 | 1 | |
| 1502265 | 1 | |
| 1502274 | 1 | |
| 1502523 | 1 | |
| 1502706 | 1 | |
| 1502736 | 1 | |
| 1502967 | 1 | |
| 1502987 | 1 | |
| 1503654 | 1 |
| Value | Count | Frequency (%) |
| 7684897 | 1 | |
| 7627650 | 1 | |
| 7525684 | 1 | |
| 7521831 | 1 | |
| 7461825 | 1 | |
| 7458034 | 1 | |
| 7403604 | 1 | |
| 7400100 | 1 | |
| 7348833 | 1 | |
| 7346642 | 1 |
自然曝光量
Real number (ℝ)
High correlation Missing
| Distinct | 919 |
|---|---|
| Distinct (%) | 78.9% |
| Missing | 12 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1245.3133 |
| Minimum | -5534 |
|---|---|
| Maximum | 7153 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 12 |
| Negative (%) | 1.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | -5534 |
|---|---|
| 5-th percentile | 213 |
| Q1 | 492 |
| median | 812 |
| Q3 | 1599 |
| 95-th percentile | 3709.2 |
| Maximum | 7153 |
| Range | 12687 |
| Interquartile range (IQR) | 1107 |
Descriptive statistics
| Standard deviation | 1206.3636 |
|---|---|
| Coefficient of variation (CV) | 0.96872297 |
| Kurtosis | 5.3627132 |
| Mean | 1245.3133 |
| Median Absolute Deviation (MAD) | 430 |
| Skewness | 1.8383567 |
| Sum | 1450790 |
| Variance | 1455313.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 674 | 6 | 0.5% |
| 409 | 6 | 0.5% |
| 535 | 5 | 0.4% |
| 463 | 4 | 0.3% |
| 439 | 4 | 0.3% |
| 517 | 4 | 0.3% |
| 495 | 4 | 0.3% |
| 324 | 4 | 0.3% |
| 588 | 4 | 0.3% |
| 267 | 4 | 0.3% |
| Other values (909) | 1120 | |
| (Missing) | 12 | 1.0% |
| Value | Count | Frequency (%) |
| -5534 | 1 | |
| -343 | 1 | |
| -249 | 1 | |
| -237 | 1 | |
| -236 | 1 | |
| -221 | 1 | |
| -214 | 1 | |
| -168 | 1 | |
| -134 | 1 | |
| -112 | 1 |
| Value | Count | Frequency (%) |
| 7153 | 1 | |
| 7003 | 1 | |
| 6898 | 1 | |
| 6707 | 1 | |
| 6679 | 1 | |
| 6616 | 1 | |
| 6525 | 1 | |
| 6441 | 1 | |
| 6406 | 1 | |
| 6129 | 1 |
自然访问量
Real number (ℝ)
High correlation Missing
| Distinct | 314 |
|---|---|
| Distinct (%) | 27.0% |
| Missing | 12 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 124.75021 |
| Minimum | -427 |
|---|---|
| Maximum | 745 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | 0.1% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | -427 |
|---|---|
| 5-th percentile | 34 |
| Q1 | 50 |
| median | 92 |
| Q3 | 169 |
| 95-th percentile | 328 |
| Maximum | 745 |
| Range | 1172 |
| Interquartile range (IQR) | 119 |
Descriptive statistics
| Standard deviation | 101.60768 |
|---|---|
| Coefficient of variation (CV) | 0.81448902 |
| Kurtosis | 3.5821943 |
| Mean | 124.75021 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | 1.4541109 |
| Sum | 145334 |
| Variance | 10324.121 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 48 | 24 | 2.0% |
| 46 | 21 | 1.8% |
| 42 | 21 | 1.8% |
| 52 | 18 | 1.5% |
| 41 | 18 | 1.5% |
| 49 | 17 | 1.4% |
| 47 | 16 | 1.4% |
| 43 | 16 | 1.4% |
| 50 | 15 | 1.3% |
| 39 | 15 | 1.3% |
| Other values (304) | 984 |
| Value | Count | Frequency (%) |
| -427 | 1 | 0.1% |
| 14 | 2 | |
| 15 | 1 | 0.1% |
| 19 | 2 | |
| 21 | 1 | 0.1% |
| 22 | 2 | |
| 23 | 1 | 0.1% |
| 24 | 1 | 0.1% |
| 25 | 1 | 0.1% |
| 26 | 4 |
| Value | Count | Frequency (%) |
| 745 | 1 | |
| 551 | 1 | |
| 532 | 1 | |
| 530 | 1 | |
| 528 | 1 | |
| 495 | 1 | |
| 489 | 1 | |
| 482 | 1 | |
| 480 | 1 | |
| 476 | 1 |
门店下单量
Real number (ℝ)
High correlation Missing
| Distinct | 147 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 12 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.893562 |
| Minimum | 0 |
|---|---|
| Maximum | 224 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 17 |
| median | 26 |
| Q3 | 60 |
| 95-th percentile | 108 |
| Maximum | 224 |
| Range | 224 |
| Interquartile range (IQR) | 43 |
Descriptive statistics
| Standard deviation | 34.50072 |
|---|---|
| Coefficient of variation (CV) | 0.84367117 |
| Kurtosis | 3.5519811 |
| Mean | 40.893562 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 1.7177411 |
| Sum | 47641 |
| Variance | 1190.2997 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18 | 51 | 4.3% |
| 15 | 51 | 4.3% |
| 19 | 45 | 3.8% |
| 17 | 45 | 3.8% |
| 12 | 33 | 2.8% |
| 20 | 33 | 2.8% |
| 16 | 31 | 2.6% |
| 14 | 30 | 2.5% |
| 11 | 30 | 2.5% |
| 21 | 30 | 2.5% |
| Other values (137) | 786 |
| Value | Count | Frequency (%) |
| 0 | 1 | 0.1% |
| 4 | 4 | 0.3% |
| 5 | 8 | 0.7% |
| 6 | 8 | 0.7% |
| 7 | 10 | 0.8% |
| 8 | 15 | |
| 9 | 21 | |
| 10 | 17 | |
| 11 | 30 | |
| 12 | 33 |
| Value | Count | Frequency (%) |
| 224 | 1 | |
| 201 | 2 | |
| 193 | 1 | |
| 191 | 1 | |
| 190 | 1 | |
| 186 | 1 | |
| 182 | 1 | |
| 175 | 1 | |
| 174 | 1 | |
| 169 | 1 |
门店实收
Real number (ℝ)
High correlation
| Distinct | 1152 |
|---|---|
| Distinct (%) | 98.6% |
| Missing | 9 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 789.76272 |
| Minimum | 30 |
|---|---|
| Maximum | 3780.11 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 30 |
|---|---|
| 5-th percentile | 204.361 |
| Q1 | 375.595 |
| median | 587.645 |
| Q3 | 1100.1525 |
| 95-th percentile | 1911.885 |
| Maximum | 3780.11 |
| Range | 3750.11 |
| Interquartile range (IQR) | 724.5575 |
Descriptive statistics
| Standard deviation | 566.84093 |
|---|---|
| Coefficient of variation (CV) | 0.71773573 |
| Kurtosis | 2.1247577 |
| Mean | 789.76272 |
| Median Absolute Deviation (MAD) | 280.6 |
| Skewness | 1.3913883 |
| Sum | 922442.86 |
| Variance | 321308.64 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1431 | 2 | 0.2% |
| 357.04 | 2 | 0.2% |
| 256.65 | 2 | 0.2% |
| 1598 | 2 | 0.2% |
| 1376 | 2 | 0.2% |
| 1073 | 2 | 0.2% |
| 1080 | 2 | 0.2% |
| 514 | 2 | 0.2% |
| 295 | 2 | 0.2% |
| 1100 | 2 | 0.2% |
| Other values (1142) | 1148 | |
| (Missing) | 9 | 0.8% |
| Value | Count | Frequency (%) |
| 30 | 1 | |
| 66 | 1 | |
| 66.16 | 1 | |
| 67 | 1 | |
| 76.35 | 1 | |
| 81 | 1 | |
| 85 | 1 | |
| 87 | 1 | |
| 88.4 | 1 | |
| 99.85 | 1 |
| Value | Count | Frequency (%) |
| 3780.11 | 1 | |
| 3367.76 | 1 | |
| 3271.86 | 1 | |
| 3171.21 | 1 | |
| 2993.95 | 1 | |
| 2992.13 | 1 | |
| 2849.17 | 1 | |
| 2815.73 | 1 | |
| 2789.79 | 1 | |
| 2757 | 1 |
门店曝光量
Real number (ℝ)
High correlation Missing
| Distinct | 1031 |
|---|---|
| Distinct (%) | 88.5% |
| Missing | 12 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2604.0815 |
| Minimum | 0 |
|---|---|
| Maximum | 11066 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 774.2 |
| Q1 | 1123 |
| median | 2016 |
| Q3 | 3605 |
| 95-th percentile | 6257.2 |
| Maximum | 11066 |
| Range | 11066 |
| Interquartile range (IQR) | 2482 |
Descriptive statistics
| Standard deviation | 1813.4936 |
|---|---|
| Coefficient of variation (CV) | 0.69640429 |
| Kurtosis | 1.451585 |
| Mean | 2604.0815 |
| Median Absolute Deviation (MAD) | 1063 |
| Skewness | 1.2303817 |
| Sum | 3033755 |
| Variance | 3288758.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1325 | 4 | 0.3% |
| 855 | 3 | 0.3% |
| 1074 | 3 | 0.3% |
| 887 | 3 | 0.3% |
| 1035 | 3 | 0.3% |
| 1112 | 3 | 0.3% |
| 1135 | 3 | 0.3% |
| 1224 | 3 | 0.3% |
| 1122 | 3 | 0.3% |
| 1000 | 3 | 0.3% |
| Other values (1021) | 1134 | |
| (Missing) | 12 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 310 | 1 | |
| 397 | 1 | |
| 514 | 1 | |
| 519 | 1 | |
| 523 | 1 | |
| 532 | 1 | |
| 534 | 1 | |
| 539 | 1 | |
| 546 | 1 |
| Value | Count | Frequency (%) |
| 11066 | 1 | |
| 10621 | 1 | |
| 10238 | 1 | |
| 10038 | 1 | |
| 9708 | 1 | |
| 9108 | 1 | |
| 8976 | 1 | |
| 8917 | 1 | |
| 8712 | 1 | |
| 8583 | 1 |
门店营业额
Real number (ℝ)
High correlation
| Distinct | 1165 |
|---|---|
| Distinct (%) | 99.7% |
| Missing | 9 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2298.8169 |
| Minimum | 164 |
|---|---|
| Maximum | 11012.76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 164 |
|---|---|
| 5-th percentile | 585.465 |
| Q1 | 1040.5175 |
| median | 1609.425 |
| Q3 | 3296.95 |
| 95-th percentile | 5632.85 |
| Maximum | 11012.76 |
| Range | 10848.76 |
| Interquartile range (IQR) | 2256.4325 |
Descriptive statistics
| Standard deviation | 1728.3866 |
|---|---|
| Coefficient of variation (CV) | 0.7518592 |
| Kurtosis | 2.1479114 |
| Mean | 2298.8169 |
| Median Absolute Deviation (MAD) | 810.095 |
| Skewness | 1.4305758 |
| Sum | 2685018.2 |
| Variance | 2987320.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5545 | 2 | 0.2% |
| 2954 | 2 | 0.2% |
| 1085 | 2 | 0.2% |
| 3391.38 | 1 | 0.1% |
| 1216.56 | 1 | 0.1% |
| 500.94 | 1 | 0.1% |
| 753.97 | 1 | 0.1% |
| 1838.31 | 1 | 0.1% |
| 754.7 | 1 | 0.1% |
| 1547.39 | 1 | 0.1% |
| Other values (1155) | 1155 | |
| (Missing) | 9 | 0.8% |
| Value | Count | Frequency (%) |
| 164 | 1 | |
| 181 | 1 | |
| 199.98 | 1 | |
| 227 | 1 | |
| 244 | 1 | |
| 244.16 | 1 | |
| 288.11 | 1 | |
| 299.62 | 1 | |
| 305 | 1 | |
| 311.94 | 1 |
| Value | Count | Frequency (%) |
| 11012.76 | 1 | |
| 9614.5 | 1 | |
| 9423.76 | 1 | |
| 9230.54 | 1 | |
| 9149 | 1 | |
| 8992.48 | 1 | |
| 8847.58 | 1 | |
| 8666 | 1 | |
| 8633 | 1 | |
| 8589.3 | 1 |
门店访问量
Real number (ℝ)
High correlation Missing
| Distinct | 440 |
|---|---|
| Distinct (%) | 37.8% |
| Missing | 12 |
| Missing (%) | 1.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 216.70129 |
| Minimum | 0 |
|---|---|
| Maximum | 985 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 58 |
| Q1 | 86 |
| median | 157 |
| Q3 | 314 |
| 95-th percentile | 547 |
| Maximum | 985 |
| Range | 985 |
| Interquartile range (IQR) | 228 |
Descriptive statistics
| Standard deviation | 161.65603 |
|---|---|
| Coefficient of variation (CV) | 0.74598558 |
| Kurtosis | 1.204818 |
| Mean | 216.70129 |
| Median Absolute Deviation (MAD) | 86 |
| Skewness | 1.2235964 |
| Sum | 252457 |
| Variance | 26132.674 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 74 | 19 | 1.6% |
| 63 | 13 | 1.1% |
| 93 | 13 | 1.1% |
| 86 | 11 | 0.9% |
| 71 | 11 | 0.9% |
| 76 | 10 | 0.8% |
| 89 | 10 | 0.8% |
| 60 | 10 | 0.8% |
| 77 | 10 | 0.8% |
| 72 | 10 | 0.8% |
| Other values (430) | 1048 | |
| (Missing) | 12 | 1.0% |
| Value | Count | Frequency (%) |
| 0 | 1 | 0.1% |
| 31 | 1 | 0.1% |
| 35 | 2 | |
| 39 | 2 | |
| 40 | 1 | 0.1% |
| 41 | 1 | 0.1% |
| 43 | 4 | |
| 44 | 4 | |
| 45 | 1 | 0.1% |
| 46 | 2 |
| Value | Count | Frequency (%) |
| 985 | 1 | |
| 871 | 1 | |
| 798 | 1 | |
| 788 | 1 | |
| 742 | 1 | |
| 727 | 1 | |
| 726 | 1 | |
| 723 | 1 | |
| 722 | 1 | |
| 718 | 1 |
Interactions
Correlations
| cpc单次点击费用 | cpc总费用 | cpc曝光量 | cpc访问量 | gmvroi | 下单转换率 | 单均gmv | 单均实收 | 实收roi | 平台i | 平台门店名称 | 无效订单 | 有效订单 | 自增主键 | 自然曝光量 | 自然访问量 | 门店ID | 门店下单量 | 门店实收 | 门店曝光量 | 门店营业额 | 门店访问量 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cpc单次点击费用 | 1.000 | 0.239 | 0.127 | 0.044 | -0.464 | 0.188 | -0.285 | -0.281 | -0.487 | 0.123 | 0.340 | 0.059 | 0.036 | 0.213 | -0.099 | -0.070 | -0.019 | 0.046 | -0.044 | 0.004 | -0.013 | -0.050 |
| cpc总费用 | 0.239 | 1.000 | 0.952 | 0.971 | -0.391 | -0.139 | -0.431 | -0.318 | -0.401 | 0.230 | 0.369 | 0.351 | 0.693 | -0.450 | 0.164 | 0.549 | -0.074 | 0.689 | 0.659 | 0.732 | 0.667 | 0.784 |
| cpc曝光量 | 0.127 | 0.952 | 1.000 | 0.958 | -0.331 | -0.168 | -0.388 | -0.267 | -0.328 | 0.174 | 0.310 | 0.335 | 0.674 | -0.467 | 0.151 | 0.549 | -0.115 | 0.669 | 0.658 | 0.751 | 0.656 | 0.780 |
| cpc访问量 | 0.044 | 0.971 | 0.958 | 1.000 | -0.302 | -0.198 | -0.372 | -0.254 | -0.306 | 0.143 | 0.363 | 0.345 | 0.698 | -0.503 | 0.190 | 0.577 | -0.036 | 0.691 | 0.682 | 0.751 | 0.683 | 0.820 |
| gmvroi | -0.464 | -0.391 | -0.331 | -0.302 | 1.000 | 0.635 | 0.412 | 0.302 | 0.936 | 0.000 | 0.055 | -0.056 | 0.031 | 0.236 | 0.031 | -0.119 | 0.135 | 0.033 | 0.108 | -0.245 | 0.100 | -0.238 |
| 下单转换率 | 0.188 | -0.139 | -0.168 | -0.198 | 0.635 | 1.000 | -0.108 | -0.193 | 0.504 | 0.106 | 0.221 | 0.127 | 0.299 | 0.376 | 0.103 | 0.015 | 0.051 | 0.307 | 0.241 | -0.078 | 0.295 | -0.107 |
| 单均gmv | -0.285 | -0.431 | -0.388 | -0.372 | 0.412 | -0.108 | 1.000 | 0.832 | 0.505 | 0.215 | 0.425 | -0.320 | -0.509 | 0.133 | -0.210 | -0.426 | 0.192 | -0.507 | -0.311 | -0.460 | -0.381 | -0.475 |
| 单均实收 | -0.281 | -0.318 | -0.267 | -0.254 | 0.302 | -0.193 | 0.832 | 1.000 | 0.524 | 0.126 | 0.320 | -0.311 | -0.468 | 0.095 | -0.272 | -0.401 | 0.139 | -0.465 | -0.218 | -0.394 | -0.368 | -0.389 |
| 实收roi | -0.487 | -0.401 | -0.328 | -0.306 | 0.936 | 0.504 | 0.505 | 0.524 | 1.000 | 0.000 | 0.055 | -0.127 | -0.065 | 0.243 | -0.044 | -0.195 | 0.101 | -0.064 | 0.093 | -0.288 | 0.010 | -0.284 |
| 平台i | 0.123 | 0.230 | 0.174 | 0.143 | 0.000 | 0.106 | 0.215 | 0.126 | 0.000 | 1.000 | 0.980 | 0.055 | 0.218 | 0.101 | 0.239 | 0.207 | 1.000 | 0.190 | 0.205 | 0.113 | 0.210 | 0.173 |
| 平台门店名称 | 0.340 | 0.369 | 0.310 | 0.363 | 0.055 | 0.221 | 0.425 | 0.320 | 0.055 | 0.980 | 1.000 | 0.158 | 0.349 | 0.399 | 0.333 | 0.299 | 0.984 | 0.336 | 0.279 | 0.332 | 0.303 | 0.360 |
| 无效订单 | 0.059 | 0.351 | 0.335 | 0.345 | -0.056 | 0.127 | -0.320 | -0.311 | -0.127 | 0.055 | 0.158 | 1.000 | 0.481 | -0.177 | 0.276 | 0.433 | -0.025 | 0.482 | 0.426 | 0.434 | 0.465 | 0.452 |
| 有效订单 | 0.036 | 0.693 | 0.674 | 0.698 | 0.031 | 0.299 | -0.509 | -0.468 | -0.065 | 0.218 | 0.349 | 0.481 | 1.000 | -0.349 | 0.573 | 0.866 | 0.020 | 0.993 | 0.945 | 0.855 | 0.986 | 0.893 |
| 自增主键 | 0.213 | -0.450 | -0.467 | -0.503 | 0.236 | 0.376 | 0.133 | 0.095 | 0.243 | 0.101 | 0.399 | -0.177 | -0.349 | 1.000 | -0.142 | -0.404 | 0.102 | -0.347 | -0.350 | -0.449 | -0.351 | -0.504 |
| 自然曝光量 | -0.099 | 0.164 | 0.151 | 0.190 | 0.031 | 0.103 | -0.210 | -0.272 | -0.044 | 0.239 | 0.333 | 0.276 | 0.573 | -0.142 | 1.000 | 0.762 | 0.073 | 0.576 | 0.561 | 0.666 | 0.589 | 0.567 |
| 自然访问量 | -0.070 | 0.549 | 0.549 | 0.577 | -0.119 | 0.015 | -0.426 | -0.401 | -0.195 | 0.207 | 0.299 | 0.433 | 0.866 | -0.404 | 0.762 | 1.000 | 0.017 | 0.871 | 0.834 | 0.879 | 0.866 | 0.912 |
| 门店ID | -0.019 | -0.074 | -0.115 | -0.036 | 0.135 | 0.051 | 0.192 | 0.139 | 0.101 | 1.000 | 0.984 | -0.025 | 0.020 | 0.102 | 0.073 | 0.017 | 1.000 | 0.009 | 0.036 | -0.064 | 0.054 | -0.006 |
| 门店下单量 | 0.046 | 0.689 | 0.669 | 0.691 | 0.033 | 0.307 | -0.507 | -0.465 | -0.064 | 0.190 | 0.336 | 0.482 | 0.993 | -0.347 | 0.576 | 0.871 | 0.009 | 1.000 | 0.938 | 0.858 | 0.979 | 0.896 |
| 门店实收 | -0.044 | 0.659 | 0.658 | 0.682 | 0.108 | 0.241 | -0.311 | -0.218 | 0.093 | 0.205 | 0.279 | 0.426 | 0.945 | -0.350 | 0.561 | 0.834 | 0.036 | 0.938 | 1.000 | 0.831 | 0.967 | 0.864 |
| 门店曝光量 | 0.004 | 0.732 | 0.751 | 0.751 | -0.245 | -0.078 | -0.460 | -0.394 | -0.288 | 0.113 | 0.332 | 0.434 | 0.855 | -0.449 | 0.666 | 0.879 | -0.064 | 0.858 | 0.831 | 1.000 | 0.847 | 0.943 |
| 门店营业额 | -0.013 | 0.667 | 0.656 | 0.683 | 0.100 | 0.295 | -0.381 | -0.368 | 0.010 | 0.210 | 0.303 | 0.465 | 0.986 | -0.351 | 0.589 | 0.866 | 0.054 | 0.979 | 0.967 | 0.847 | 1.000 | 0.883 |
| 门店访问量 | -0.050 | 0.784 | 0.780 | 0.820 | -0.238 | -0.107 | -0.475 | -0.389 | -0.284 | 0.173 | 0.360 | 0.452 | 0.893 | -0.504 | 0.567 | 0.912 | -0.006 | 0.896 | 0.864 | 0.943 | 0.883 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| updateTime | 平台i | 门店ID | 平台门店名称 | 日期 | cpc单次点击费用 | cpc总费用 | cpc曝光量 | cpc访问量 | gmvroi | 下单转换率 | 单均gmv | 单均实收 | 实收roi | 无效订单 | 有效订单 | 自增主键 | 自然曝光量 | 自然访问量 | 门店下单量 | 门店实收 | 门店曝光量 | 门店营业额 | 门店访问量 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2019/12/12 11:54 | 美团 | 8184590 | 蛙小辣火锅杯（合生汇店） | 2019-12-10 | 1.30 | 225.65 | 2711 | 173 | 7.43 | 0.17 | 57.48 | 19.80 | 2.56 | 0.0 | 59.0 | 1501603 | 1427.0 | 159.0 | 56.0 | 1167.97 | 4138.0 | 3391.38 | 332.0 |
| 1 | 2019/12/12 11:54 | 美团 | 8223184 | 蛙小辣美蛙火锅杯（大宁国际店） | 2019-12-10 | 1.54 | 261.10 | 3665 | 169 | 4.30 | 0.13 | 52.99 | 18.88 | 1.53 | 0.0 | 35.0 | 1501605 | 11.0 | 86.0 | 32.0 | 660.73 | 3676.0 | 1854.76 | 255.0 |
| 2 | 2019/12/12 11:54 | 美团 | 8106681 | 蛙小辣·美蛙火锅杯（长风大悦城店） | 2019-12-10 | 1.38 | 177.50 | 2115 | 129 | 6.75 | 0.18 | 51.49 | 20.38 | 2.67 | 1.0 | 53.0 | 1502265 | 874.0 | 165.0 | 53.0 | 1080.31 | 2989.0 | 2728.72 | 294.0 |
| 3 | 2019/12/12 11:54 | 美团 | 8165842 | 蛙小辣·美蛙火锅杯（虹口足球场店） | 2019-12-10 | 1.47 | 240.30 | 2937 | 164 | 7.43 | 0.19 | 56.35 | 19.25 | 2.54 | 2.0 | 64.0 | 1502274 | 614.0 | 162.0 | 63.0 | 1231.86 | 3551.0 | 3606.10 | 326.0 |
| 4 | 2019/12/12 11:54 | 饿了么 | 2001220953 | 利芳·一人食大盘鸡(国定路店) | 2019-12-10 | 1.55 | 623.50 | 4190 | 401 | 5.35 | 0.17 | 49.69 | 12.71 | 1.37 | 0.0 | 132.0 | 1502523 | 1872.0 | 387.0 | 132.0 | 1677.96 | 6062.0 | 6558.49 | 788.0 |
| 5 | 2019/12/12 11:54 | 饿了么 | 2000555792 | 蛙小辣·美蛙火锅杯(虹口足球场店) | 2019-12-10 | 1.61 | 207.80 | 1628 | 129 | 3.17 | 0.09 | 56.10 | 18.20 | 1.03 | 0.0 | 32.0 | 1502706 | 802.0 | 223.0 | 32.0 | 582.44 | 2430.0 | 1795.34 | 352.0 |
| 6 | 2019/12/12 11:54 | 饿了么 | 2001104355 | 蛙小辣·美蛙火锅杯(宝山店) | 2019-12-10 | 1.25 | 198.50 | 2043 | 159 | 6.52 | 0.13 | 64.65 | 25.62 | 2.58 | 0.0 | 54.0 | 1502736 | 1108.0 | 254.0 | 52.0 | 1383.31 | 3151.0 | 3491.02 | 413.0 |
| 7 | 2019/12/12 11:54 | 饿了么 | 2000507076 | 蛙小辣火锅杯(五角场店) | 2019-12-10 | 1.35 | 166.40 | 1705 | 123 | 6.40 | 0.15 | 57.81 | 21.28 | 2.36 | 1.0 | 63.0 | 1502967 | 1470.0 | 284.0 | 61.0 | 1340.47 | 3175.0 | 3642.10 | 407.0 |
| 8 | 2019/12/12 11:54 | 饿了么 | 2001020019 | 蛙小辣·美蛙火锅杯(真如店) | 2019-12-10 | 1.51 | 140.30 | 1376 | 93 | 4.82 | 0.14 | 53.45 | 14.66 | 1.32 | 0.0 | 46.0 | 1502987 | 1394.0 | 245.0 | 46.0 | 674.16 | 2770.0 | 2458.60 | 338.0 |
| 9 | 2019/12/12 12:49 | 美团 | 8106681 | 蛙小辣·美蛙火锅杯（长风大悦城店） | 2019-12-09 | 1.40 | 195.35 | 2329 | 140 | 6.87 | 0.20 | 47.13 | 17.20 | 2.51 | 3.0 | 63.0 | 1503654 | 839.0 | 160.0 | 61.0 | 1083.59 | 3168.0 | 2969.08 | 300.0 |
| updateTime | 平台i | 门店ID | 平台门店名称 | 日期 | cpc单次点击费用 | cpc总费用 | cpc曝光量 | cpc访问量 | gmvroi | 下单转换率 | 单均gmv | 单均实收 | 实收roi | 无效订单 | 有效订单 | 自增主键 | 自然曝光量 | 自然访问量 | 门店下单量 | 门店实收 | 门店曝光量 | 门店营业额 | 门店访问量 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1167 | 2020/8/2 14:29 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-08-01 | 2.25 | 98.90 | 837 | 44 | 5.38 | 0.23 | 52.43 | 16.75 | 1.72 | 1.0 | 59.0 | 5216288 | 2428.0 | 203.0 | 57.0 | 988.54 | 3265.0 | 3093.24 | 247.0 |
| 1168 | 2020/7/16 14:19 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-07-14 | 2.25 | 184.18 | 1351 | 82 | 5.03 | 0.23 | 49.43 | 15.95 | 1.62 | 1.0 | 65.0 | 4632242 | 2561.0 | 189.0 | 62.0 | 1036.77 | 3912.0 | 3212.68 | 271.0 |
| 1169 | 2020/8/3 14:28 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-08-02 | 2.19 | 98.50 | 882 | 45 | 5.48 | 0.24 | 49.83 | 14.22 | 1.56 | 1.0 | 60.0 | 5248702 | 2445.0 | 196.0 | 58.0 | 853.39 | 3327.0 | 2989.62 | 241.0 |
| 1170 | 2020/7/29 14:29 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-07-28 | 2.05 | 211.27 | 1899 | 103 | 6.69 | 0.26 | 52.78 | 18.10 | 2.30 | 1.0 | 78.0 | 5092152 | 2060.0 | 193.0 | 77.0 | 1411.88 | 3959.0 | 4116.74 | 296.0 |
| 1171 | 2020/7/21 14:29 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-07-20 | 2.24 | 236.97 | 2059 | 106 | 6.60 | 0.29 | 51.66 | 17.67 | 2.26 | 1.0 | 73.0 | 4844752 | 1827.0 | 146.0 | 72.0 | 1289.92 | 3886.0 | 3771.52 | 252.0 |
| 1172 | 2020/9/3 14:33 | 饿了么 | 2001104355 | 蛙小辣·美蛙火锅杯麻辣烫(宝山店) | 2020-09-02 | 1.72 | 32.60 | 251 | 19 | 13.44 | 0.38 | 60.93 | 20.59 | 4.54 | 2.0 | 27.0 | 6408364 | 676.0 | 55.0 | 28.0 | 555.97 | 927.0 | 1645.22 | 74.0 |
| 1173 | 2020/7/25 14:28 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-07-24 | 2.14 | 175.47 | 1126 | 82 | 5.60 | 0.24 | 48.97 | 15.02 | 1.72 | 2.0 | 57.0 | 4969885 | 1808.0 | 147.0 | 56.0 | 855.86 | 2934.0 | 2791.10 | 229.0 |
| 1174 | 2020/7/18 14:28 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-07-17 | 2.23 | 185.10 | 1548 | 83 | 5.38 | 0.24 | 49.96 | 16.89 | 1.82 | 2.0 | 62.0 | 4755649 | 1795.0 | 167.0 | 60.0 | 1047.09 | 3343.0 | 3097.62 | 250.0 |
| 1175 | 2020/7/28 14:29 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-07-27 | 1.99 | 141.25 | 1221 | 71 | 6.21 | 0.27 | 45.95 | 13.76 | 1.86 | 2.0 | 62.0 | 5064132 | 1905.0 | 152.0 | 60.0 | 853.16 | 3126.0 | 2848.94 | 223.0 |
| 1176 | 2020/7/23 14:30 | 饿了么 | 337460136 | 拌客·干拌麻辣烫(武宁路店) | 2020-07-21 | 2.06 | 134.19 | 1131 | 65 | 6.48 | 0.27 | 48.83 | 15.93 | 2.11 | 2.0 | 65.0 | 4877519 | 2188.0 | 165.0 | 63.0 | 1035.14 | 3319.0 | 3173.74 | 230.0 |